#+TITLE:PostGreSQL Cheatsheat
#+AUTHOR:Joshua Branson

* Set up postgresql user

 When you have postgresql running, execute these commands.
 Substituting "joshua" for your non-root username.  This lets you
 connect to psql without having to provide any login details.  It is
 quite handy.  Note that I have created a database that is the same
 name as my username, but your database can be whatever name you want
 to give it.
 
   #+BEGIN_SRC sh
     joshua@dobby ~$ sudo -u postgres -s /bin/sh
     Password:
     sh-5.0$ createuser joshua
     sh-5.0$ createdb joshua
     sh-5.0$

     joshua@dobby ~$ psql
     joshua=> \c joshua
     You are now connected to database "joshua" as user "joshua".
   #+END_SRC
